﻿IF object_id(N'dbo.UDS_CM_ClientContact', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_CM_ClientContact] (
        [ID]               int            NOT NULL identity(1, 1),
        [ClientID]         int            NOT NULL,
        [MarketmanID]      int            NULL,
        [UpdateTime]       datetime       NULL,
        [ContactTimes]     int            NULL,
        [CurStatus]        nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ContactAim]       nvarchar(500)  COLLATE Chinese_PRC_CI_AS NULL,
        [SellMoney]        int            NULL,
        [BargainPrognosis] nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [ContactType]      nvarchar(50)   COLLATE Chinese_PRC_CI_AS NULL,
        [Fee]              int            NULL,
        [ContactContent]   nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
        [NextContactAim]   nvarchar(1000) COLLATE Chinese_PRC_CI_AS NULL,
        [NextContactTime]  datetime       NULL,
        [FeeUsed]          nvarchar(100)  COLLATE Chinese_PRC_CI_AS NULL,
        [ContactTime]      datetime       NULL,

        CONSTRAINT [PK_UDS_CM_ClientContact] PRIMARY KEY CLUSTERED ([ID] asc),
        CONSTRAINT [FK_UDS_CM_ClientContact_UDS_Staff] FOREIGN KEY ([MarketmanID]) REFERENCES [dbo].[UDS_Staff] ([Staff_ID])
    );
END
GO
